﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="databaseDataSet" targetNamespace="http://tempuri.org/databaseDataSet.xsd" xmlns:mstns="http://tempuri.org/databaseDataSet.xsd" xmlns="http://tempuri.org/databaseDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="sDBConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="sDBConnection (Settings)" PropertyReference="ApplicationSettings.MyForumWatcher.Properties.Settings.GlobalReference.Default.sDBConnection" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoriesTableAdapter" GeneratorDataComponentClassName="CategoriesTableAdapter" Name="Categories" UserDataComponentName="CategoriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sDBConnection (Settings)" DbObjectName="Categories" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Categories` WHERE ((`GUID_Category` = ?) AND ((? = 1 AND `GUID_Forums` IS NULL) OR (`GUID_Forums` = ?)) AND ((? = 1 AND `CategoryName` IS NULL) OR (`CategoryName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_Forums" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CategoryName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CategoryName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Categories` (`GUID_Category`, `GUID_Forums`, `CategoryName`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CategoryName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GUID_Category, GUID_Forums, CategoryName FROM Categories</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Categories` SET `GUID_Category` = ?, `GUID_Forums` = ?, `CategoryName` = ? WHERE ((`GUID_Category` = ?) AND ((? = 1 AND `GUID_Forums` IS NULL) OR (`GUID_Forums` = ?)) AND ((? = 1 AND `CategoryName` IS NULL) OR (`CategoryName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CategoryName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Category" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_Forums" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CategoryName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CategoryName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GUID_Category" DataSetColumn="GUID_Category" />
              <Mapping SourceColumn="GUID_Forums" DataSetColumn="GUID_Forums" />
              <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ForumsTableAdapter" GeneratorDataComponentClassName="ForumsTableAdapter" Name="Forums" UserDataComponentName="ForumsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sDBConnection (Settings)" DbObjectName="Forums" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Forums` WHERE ((`GUID_Forums` = ?) AND ((? = 1 AND `ForumsName` IS NULL) OR (`ForumsName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ForumsName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ForumsName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Forums` (`GUID_Forums`, `ForumsName`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ForumsName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GUID_Forums, ForumsName FROM Forums</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Forums` SET `GUID_Forums` = ?, `ForumsName` = ? WHERE ((`GUID_Forums` = ?) AND ((? = 1 AND `ForumsName` IS NULL) OR (`ForumsName` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ForumsName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Forums" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Forums" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ForumsName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ForumsName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ForumsName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GUID_Forums" DataSetColumn="GUID_Forums" />
              <Mapping SourceColumn="ForumsName" DataSetColumn="ForumsName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PostTableAdapter" GeneratorDataComponentClassName="PostTableAdapter" Name="Post" UserDataComponentName="PostTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sDBConnection (Settings)" DbObjectName="Post" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Post` WHERE ((`GUID_Post` = ?) AND ((? = 1 AND `GUID_ThreadType` IS NULL) OR (`GUID_ThreadType` = ?)) AND ((? = 1 AND `PostName` IS NULL) OR (`PostName` = ?)) AND ((? = 1 AND `Post` IS NULL) OR (`Post` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Post" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_ThreadType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PostName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PostName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Post" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Post` (`GUID_Post`, `GUID_ThreadType`, `PostName`, `Post`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Post" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PostName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GUID_Post, GUID_ThreadType, PostName, Post FROM Post</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Post` SET `GUID_Post` = ?, `GUID_ThreadType` = ?, `PostName` = ?, `Post` = ? WHERE ((`GUID_Post` = ?) AND ((? = 1 AND `GUID_ThreadType` IS NULL) OR (`GUID_ThreadType` = ?)) AND ((? = 1 AND `PostName` IS NULL) OR (`PostName` = ?)) AND ((? = 1 AND `Post` IS NULL) OR (`Post` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Post" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="PostName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Post" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_ThreadType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PostName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_PostName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="PostName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Post" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Post" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Post" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GUID_Post" DataSetColumn="GUID_Post" />
              <Mapping SourceColumn="GUID_ThreadType" DataSetColumn="GUID_ThreadType" />
              <Mapping SourceColumn="PostName" DataSetColumn="PostName" />
              <Mapping SourceColumn="Post" DataSetColumn="Post" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ThreadTypeTableAdapter" GeneratorDataComponentClassName="ThreadTypeTableAdapter" Name="ThreadType" UserDataComponentName="ThreadTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="sDBConnection (Settings)" DbObjectName="ThreadType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ThreadType` WHERE ((`GUID_ThreadType` = ?) AND ((? = 1 AND `GUID_Categories` IS NULL) OR (`GUID_Categories` = ?)) AND ((? = 1 AND `ThreadType` IS NULL) OR (`ThreadType` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Categories" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ThreadType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ThreadType` (`GUID_ThreadType`, `GUID_Categories`, `ThreadType`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Categories" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GUID_ThreadType, GUID_Categories, ThreadType FROM ThreadType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ThreadType` SET `GUID_ThreadType` = ?, `GUID_Categories` = ?, `ThreadType` = ? WHERE ((`GUID_ThreadType` = ?) AND ((? = 1 AND `GUID_Categories` IS NULL) OR (`GUID_Categories` = ?)) AND ((? = 1 AND `ThreadType` IS NULL) OR (`ThreadType` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="GUID_Categories" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GUID_Categories" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_GUID_Categories" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="GUID_Categories" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ThreadType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ThreadType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ThreadType" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GUID_ThreadType" DataSetColumn="GUID_ThreadType" />
              <Mapping SourceColumn="GUID_Categories" DataSetColumn="GUID_Categories" />
              <Mapping SourceColumn="ThreadType" DataSetColumn="ThreadType" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="databaseDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="databaseDataSet" msprop:Generator_UserDSName="databaseDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Categories" msprop:Generator_TableClassName="CategoriesDataTable" msprop:Generator_TableVarName="tableCategories" msprop:Generator_TablePropName="Categories" msprop:Generator_RowDeletingName="CategoriesRowDeleting" msprop:Generator_UserTableName="Categories" msprop:Generator_RowChangingName="CategoriesRowChanging" msprop:Generator_RowEvHandlerName="CategoriesRowChangeEventHandler" msprop:Generator_RowDeletedName="CategoriesRowDeleted" msprop:Generator_RowEvArgName="CategoriesRowChangeEvent" msprop:Generator_RowChangedName="CategoriesRowChanged" msprop:Generator_RowClassName="CategoriesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GUID_Category" msprop:Generator_ColumnVarNameInTable="columnGUID_Category" msprop:Generator_ColumnPropNameInRow="GUID_Category" msprop:Generator_ColumnPropNameInTable="GUID_CategoryColumn" msprop:Generator_UserColumnName="GUID_Category">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GUID_Forums" msprop:Generator_ColumnVarNameInTable="columnGUID_Forums" msprop:Generator_ColumnPropNameInRow="GUID_Forums" msprop:Generator_ColumnPropNameInTable="GUID_ForumsColumn" msprop:Generator_UserColumnName="GUID_Forums" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Forums" msprop:Generator_TableClassName="ForumsDataTable" msprop:Generator_TableVarName="tableForums" msprop:Generator_TablePropName="Forums" msprop:Generator_RowDeletingName="ForumsRowDeleting" msprop:Generator_UserTableName="Forums" msprop:Generator_RowChangingName="ForumsRowChanging" msprop:Generator_RowEvHandlerName="ForumsRowChangeEventHandler" msprop:Generator_RowDeletedName="ForumsRowDeleted" msprop:Generator_RowEvArgName="ForumsRowChangeEvent" msprop:Generator_RowChangedName="ForumsRowChanged" msprop:Generator_RowClassName="ForumsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GUID_Forums" msprop:Generator_ColumnVarNameInTable="columnGUID_Forums" msprop:Generator_ColumnPropNameInRow="GUID_Forums" msprop:Generator_ColumnPropNameInTable="GUID_ForumsColumn" msprop:Generator_UserColumnName="GUID_Forums">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ForumsName" msprop:Generator_ColumnVarNameInTable="columnForumsName" msprop:Generator_ColumnPropNameInRow="ForumsName" msprop:Generator_ColumnPropNameInTable="ForumsNameColumn" msprop:Generator_UserColumnName="ForumsName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Post" msprop:Generator_TableClassName="PostDataTable" msprop:Generator_TableVarName="tablePost" msprop:Generator_TablePropName="Post" msprop:Generator_RowDeletingName="PostRowDeleting" msprop:Generator_UserTableName="Post" msprop:Generator_RowChangingName="PostRowChanging" msprop:Generator_RowEvHandlerName="PostRowChangeEventHandler" msprop:Generator_RowDeletedName="PostRowDeleted" msprop:Generator_RowEvArgName="PostRowChangeEvent" msprop:Generator_RowChangedName="PostRowChanged" msprop:Generator_RowClassName="PostRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GUID_Post" msprop:Generator_ColumnVarNameInTable="columnGUID_Post" msprop:Generator_ColumnPropNameInRow="GUID_Post" msprop:Generator_ColumnPropNameInTable="GUID_PostColumn" msprop:Generator_UserColumnName="GUID_Post">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GUID_ThreadType" msprop:Generator_ColumnVarNameInTable="columnGUID_ThreadType" msprop:Generator_ColumnPropNameInRow="GUID_ThreadType" msprop:Generator_ColumnPropNameInTable="GUID_ThreadTypeColumn" msprop:Generator_UserColumnName="GUID_ThreadType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostName" msprop:Generator_ColumnVarNameInTable="columnPostName" msprop:Generator_ColumnPropNameInRow="PostName" msprop:Generator_ColumnPropNameInTable="PostNameColumn" msprop:Generator_UserColumnName="PostName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Post" msprop:Generator_ColumnVarNameInTable="columnPost" msprop:Generator_ColumnPropNameInRow="Post" msprop:Generator_ColumnPropNameInTable="PostColumn" msprop:Generator_UserColumnName="Post" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ThreadType" msprop:Generator_TableClassName="ThreadTypeDataTable" msprop:Generator_TableVarName="tableThreadType" msprop:Generator_TablePropName="ThreadType" msprop:Generator_RowDeletingName="ThreadTypeRowDeleting" msprop:Generator_UserTableName="ThreadType" msprop:Generator_RowChangingName="ThreadTypeRowChanging" msprop:Generator_RowEvHandlerName="ThreadTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ThreadTypeRowDeleted" msprop:Generator_RowEvArgName="ThreadTypeRowChangeEvent" msprop:Generator_RowChangedName="ThreadTypeRowChanged" msprop:Generator_RowClassName="ThreadTypeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GUID_ThreadType" msprop:Generator_ColumnVarNameInTable="columnGUID_ThreadType" msprop:Generator_ColumnPropNameInRow="GUID_ThreadType" msprop:Generator_ColumnPropNameInTable="GUID_ThreadTypeColumn" msprop:Generator_UserColumnName="GUID_ThreadType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GUID_Categories" msprop:Generator_ColumnVarNameInTable="columnGUID_Categories" msprop:Generator_ColumnPropNameInRow="GUID_Categories" msprop:Generator_ColumnPropNameInTable="GUID_CategoriesColumn" msprop:Generator_UserColumnName="GUID_Categories" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ThreadType" msprop:Generator_ColumnVarNameInTable="columnThreadType" msprop:Generator_ColumnPropNameInRow="ThreadType" msprop:Generator_ColumnPropNameInTable="ThreadTypeColumn" msprop:Generator_UserColumnName="ThreadType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Categories" />
      <xs:field xpath="mstns:GUID_Category" />
    </xs:unique>
    <xs:unique name="Forums_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Forums" />
      <xs:field xpath="mstns:GUID_Forums" />
    </xs:unique>
    <xs:unique name="Post_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Post" />
      <xs:field xpath="mstns:GUID_Post" />
    </xs:unique>
    <xs:unique name="ThreadType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ThreadType" />
      <xs:field xpath="mstns:GUID_ThreadType" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="ForumsCategories" msdata:parent="Forums" msdata:child="Categories" msdata:parentkey="GUID_Forums" msdata:childkey="GUID_Forums" msprop:Generator_UserChildTable="Categories" msprop:Generator_ChildPropName="GetCategoriesRows" msprop:Generator_UserParentTable="Forums" msprop:Generator_UserRelationName="ForumsCategories" msprop:Generator_RelationVarName="relationForumsCategories" msprop:Generator_ParentPropName="ForumsRow" />
      <msdata:Relationship name="ThreadTypePost" msdata:parent="ThreadType" msdata:child="Post" msdata:parentkey="GUID_ThreadType" msdata:childkey="GUID_ThreadType" msprop:Generator_UserChildTable="Post" msprop:Generator_ChildPropName="GetPostRows" msprop:Generator_UserParentTable="ThreadType" msprop:Generator_UserRelationName="ThreadTypePost" msprop:Generator_RelationVarName="relationThreadTypePost" msprop:Generator_ParentPropName="ThreadTypeRow" />
      <msdata:Relationship name="CategoriesThreadType" msdata:parent="Categories" msdata:child="ThreadType" msdata:parentkey="GUID_Category" msdata:childkey="GUID_Categories" msprop:Generator_UserChildTable="ThreadType" msprop:Generator_ChildPropName="GetThreadTypeRows" msprop:Generator_UserParentTable="Categories" msprop:Generator_UserRelationName="CategoriesThreadType" msprop:Generator_RelationVarName="relationCategoriesThreadType" msprop:Generator_ParentPropName="CategoriesRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>